package com.cul;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;

/**
 * Hello world!
 *
 */
public class App 
{
    public static void main(String[] args) {
        SqlFromExcelParam sqlFromExcelParam = new SqlFromExcelParam();

        List<String> columnNames = new ArrayList<String>();
        columnNames.add("字段名");
        columnNames.add("字段类型");
        columnNames.add("是否非空");
        columnNames.add("说明");


        sqlFromExcelParam.setExcelFilepath("C:\\Users\\12944\\Desktop\\建表\\新-LMIS对外统一服务接口-table.xlsx")
                .setSheetName("运单指令")
                .setTitleRowNO(4)
                .setTitleNames(columnNames)
                .setStartRow(62)
                .setEndRow(73)
                .setSqlFilepath("C:\\Users\\12944\\Desktop\\建表\\out_order_detail.sql")
                .setTableName("out_oder_detail");
        System.out.println("sqlFromExcelParam = [" + sqlFromExcelParam.toString() + "]");

        ExcelUtil.generateSqlFromExcel(sqlFromExcelParam);

        System.out.println("Hello World!");
    }
}
